#!/bin/bash
sqoop export --connect jdbc:mysql://localhost:3306/licai \
--username root \
--password 123456 \
--table dm_org_order_summary \
--driver com.mysql.jdbc.Driver \
--export-dir '/user/hive/warehouse/dm00.db/dm_org_order_summary/*' \
--input-fields-terminated-by ',' \
--input-null-string '\\N' \
--input-null-non-string '\\N' \
-m 1 \
--validate ;


#!/bin/bash
sqoop export --connect jdbc:mysql://localhost:3306/licai \
--username root \
--password 123456 \
--table dm_place_order_summary \
--driver com.mysql.jdbc.Driver \
--export-dir '/user/hive/warehouse/dm00.db/dm_place_order_summary/*' \
--input-fields-terminated-by ',' \
--input-null-string '\\N' \
--input-null-non-string '\\N' \
-m 1 \
--validate ;


#!/bin/bash
sqoop export --connect jdbc:mysql://localhost:3306/licai \
--username root \
--password 123456 \
--table dm_customer_order_summary \
--driver com.mysql.jdbc.Driver \
--export-dir '/user/hive/warehouse/dm00.db/dm_customer_order_summary/*' \
--input-fields-terminated-by ',' \
--input-null-string '\\N' \
--input-null-non-string '\\N' \
-m 1 \
--validate ;
